﻿CREATE TABLE [dbo].[SQLAgentJobDetails] (
    [JobID]           INT           NOT NULL IDENTITY,
    [ServiceID]       INT           NOT NULL,
    [JobName]         VARCHAR (4000) NOT NULL,
    [Enabled]         VARCHAR (4000)  NULL,
    [LastRunStatus]   VARCHAR (4000)  NULL,
    [Category]        VARCHAR (4000)  NULL,
    [LastRunDateTime] VARCHAR (4000) NULL,
    [Duration]        INT           NULL,
    CONSTRAINT [PK_SQLAgentJobDetails_1] PRIMARY KEY CLUSTERED ([JobID] ASC),
    CONSTRAINT [FK_JobDetails_JobDetails] FOREIGN KEY ([ServiceID]) REFERENCES [dbo].[Service] ([ServiceID])
);





